Overview
Brought to you by YData
Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 103024 |
| Missing cells | 471498 |
| Missing cells (%) | 24.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 71.1 MiB |
| Average record size in memory | 723.2 B |
Variable types
| DateTime | 2 |
|---|---|
| Text | 2 |
| Categorical | 8 |
| Numeric | 6 |
| Boolean | 1 |
Booking_Status is highly overall correlated with C_TAT and 9 other fields | High correlation |
C_TAT is highly overall correlated with Booking_Status | High correlation |
Canceled_Rides_by_Customer is highly overall correlated with Booking_Status and 2 other fields | High correlation |
Canceled_Rides_by_Driver is highly overall correlated with Booking_Status and 2 other fields | High correlation |
Customer_Rating is highly overall correlated with Booking_Status | High correlation |
Driver_Ratings is highly overall correlated with Booking_Status and 2 other fields | High correlation |
Incomplete_Rides is highly overall correlated with Booking_Status and 1 other fields | High correlation |
Incomplete_Rides_Reason is highly overall correlated with Booking_Status and 1 other fields | High correlation |
Payment_Method is highly overall correlated with Booking_Status | High correlation |
Ride_Distance is highly overall correlated with Booking_Status and 2 other fields | High correlation |
V_TAT is highly overall correlated with Booking_Status | High correlation |
Incomplete_Rides is highly imbalanced (66.7%) | Imbalance |
V_TAT has 39057 (37.9%) missing values | Missing |
C_TAT has 39057 (37.9%) missing values | Missing |
Canceled_Rides_by_Customer has 92525 (89.8%) missing values | Missing |
Canceled_Rides_by_Driver has 84590 (82.1%) missing values | Missing |
Incomplete_Rides has 39057 (37.9%) missing values | Missing |
Incomplete_Rides_Reason has 99098 (96.2%) missing values | Missing |
Payment_Method has 39057 (37.9%) missing values | Missing |
Customer_Rating has 39057 (37.9%) missing values | Missing |
Booking_ID has unique values | Unique |
Ride_Distance has 39057 (37.9%) zeros | Zeros |
Reproduction
| Analysis started | 2025-09-13 12:59:22.315544 |
|---|---|
| Analysis finished | 2025-09-13 13:00:51.282475 |
| Duration | 1 minute and 28.97 seconds |
| Software version | ydata-profiling vv4.16.1 |
| Download configuration | config.json |
Variables
Date
Date
| Distinct | 40214 |
|---|---|
| Distinct (%) | 39.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 805.0 KiB |
| Minimum | 2024-01-07 00:00:00 |
|---|---|
| Maximum | 2024-12-07 23:59:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Time
Date
| Distinct | 1440 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 805.0 KiB |
| Minimum | 2025-09-13 00:00:00 |
|---|---|
| Maximum | 2025-09-13 23:59:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
Booking_ID
Text
Unique
| Distinct | 103024 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.1 MiB |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Unique
| Unique | 103024 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | CNR7153255142 |
|---|---|
| 2nd row | CNR2940424040 |
| 3rd row | CNR2982357879 |
| 4th row | CNR2395710036 |
| 5th row | CNR1797421769 |
| Value | Count | Frequency (%) |
| cnr7153255142 | 1 | < 0.1% |
| cnr8181602032 | 1 | < 0.1% |
| cnr1797421769 | 1 | < 0.1% |
| cnr8787177882 | 1 | < 0.1% |
| cnr3612067560 | 1 | < 0.1% |
| cnr5374902489 | 1 | < 0.1% |
| cnr5030602354 | 1 | < 0.1% |
| cnr6328453219 | 1 | < 0.1% |
| cnr4787583516 | 1 | < 0.1% |
| cnr7943634301 | 1 | < 0.1% |
| Other values (103014) | 103014 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 104631 | 7.8% |
| 5 | 104545 | 7.8% |
| 6 | 104394 | 7.8% |
| 4 | 104286 | 7.8% |
| 7 | 104276 | 7.8% |
| 8 | 104106 | 7.8% |
| 9 | 103771 | 7.7% |
| 3 | 103764 | 7.7% |
| 2 | 103624 | 7.7% |
| C | 103024 | 7.7% |
| Other values (3) | 298891 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1030240 | |
| Uppercase Letter | 309072 | 23.1% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 104631 | |
| 5 | 104545 | |
| 6 | 104394 | |
| 4 | 104286 | |
| 7 | 104276 | |
| 8 | 104106 | |
| 9 | 103771 | |
| 3 | 103764 | |
| 2 | 103624 | |
| 0 | 92843 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 103024 | |
| N | 103024 | |
| R | 103024 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1030240 | |
| Latin | 309072 | 23.1% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 104631 | |
| 5 | 104545 | |
| 6 | 104394 | |
| 4 | 104286 | |
| 7 | 104276 | |
| 8 | 104106 | |
| 9 | 103771 | |
| 3 | 103764 | |
| 2 | 103624 | |
| 0 | 92843 |
Latin
| Value | Count | Frequency (%) |
| C | 103024 | |
| N | 103024 | |
| R | 103024 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1339312 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 104631 | 7.8% |
| 5 | 104545 | 7.8% |
| 6 | 104394 | 7.8% |
| 4 | 104286 | 7.8% |
| 7 | 104276 | 7.8% |
| 8 | 104106 | 7.8% |
| 9 | 103771 | 7.7% |
| 3 | 103764 | 7.7% |
| 2 | 103624 | 7.7% |
| C | 103024 | 7.7% |
| Other values (3) | 298891 |
Booking_Status
Categorical
High correlation
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.9 MiB |
| Success | |
|---|---|
| Canceled by Driver | |
| Canceled by Customer | |
| Driver Not Found |
Length
| Max length | 20 |
|---|---|
| Median length | 7 |
| Mean length | 11.177444 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Canceled by Driver |
|---|---|
| 2nd row | Success |
| 3rd row | Success |
| 4th row | Canceled by Customer |
| 5th row | Success |
Common Values
| Value | Count | Frequency (%) |
| Success | 63967 | |
| Canceled by Driver | 18434 | 17.9% |
| Canceled by Customer | 10499 | 10.2% |
| Driver Not Found | 10124 | 9.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| success | 63967 | |
| canceled | 28933 | |
| by | 28933 | |
| driver | 28558 | |
| customer | 10499 | 5.8% |
| not | 10124 | 5.6% |
| found | 10124 | 5.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 160890 | |
| c | 156867 | |
| s | 138433 | |
| u | 84590 | 7.3% |
| 78114 | 6.8% | |
| r | 67615 | 5.9% |
| S | 63967 | 5.6% |
| C | 39432 | 3.4% |
| n | 39057 | 3.4% |
| d | 39057 | 3.4% |
| Other values (12) | 283523 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 921226 | |
| Uppercase Letter | 152205 | 13.2% |
| Space Separator | 78114 | 6.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 160890 | |
| c | 156867 | |
| s | 138433 | |
| u | 84590 | |
| r | 67615 | |
| n | 39057 | 4.2% |
| d | 39057 | 4.2% |
| o | 30747 | 3.3% |
| y | 28933 | 3.1% |
| b | 28933 | 3.1% |
| Other values (6) | 146104 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 63967 | |
| C | 39432 | |
| D | 28558 | |
| N | 10124 | 6.7% |
| F | 10124 | 6.7% |
Space Separator
| Value | Count | Frequency (%) |
| 78114 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1073431 | |
| Common | 78114 | 6.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 160890 | |
| c | 156867 | |
| s | 138433 | |
| u | 84590 | 7.9% |
| r | 67615 | 6.3% |
| S | 63967 | 6.0% |
| C | 39432 | 3.7% |
| n | 39057 | 3.6% |
| d | 39057 | 3.6% |
| o | 30747 | 2.9% |
| Other values (11) | 252776 |
Common
| Value | Count | Frequency (%) |
| 78114 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1151545 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 160890 | |
| c | 156867 | |
| s | 138433 | |
| u | 84590 | 7.3% |
| 78114 | 6.8% | |
| r | 67615 | 5.9% |
| S | 63967 | 5.6% |
| C | 39432 | 3.4% |
| n | 39057 | 3.4% |
| d | 39057 | 3.4% |
| Other values (12) | 283523 |
Customer_ID
Text
| Distinct | 94544 |
|---|---|
| Distinct (%) | 91.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.7 MiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Unique
| Unique | 86590 ? |
|---|---|
| Unique (%) | 84.0% |
Sample
| 1st row | CID713523 |
|---|---|
| 2nd row | CID225428 |
| 3rd row | CID270156 |
| 4th row | CID581320 |
| 5th row | CID939555 |
| Value | Count | Frequency (%) |
| cid954071 | 5 | < 0.1% |
| cid966929 | 4 | < 0.1% |
| cid980727 | 4 | < 0.1% |
| cid836942 | 4 | < 0.1% |
| cid189965 | 4 | < 0.1% |
| cid268274 | 4 | < 0.1% |
| cid819034 | 4 | < 0.1% |
| cid952434 | 4 | < 0.1% |
| cid969725 | 4 | < 0.1% |
| cid381415 | 4 | < 0.1% |
| Other values (94534) | 102983 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 103024 | |
| I | 103024 | |
| D | 103024 | |
| 8 | 63221 | 6.8% |
| 1 | 63184 | 6.8% |
| 4 | 63009 | 6.8% |
| 3 | 62996 | 6.8% |
| 2 | 62936 | 6.8% |
| 9 | 62906 | 6.8% |
| 7 | 62853 | 6.8% |
| Other values (3) | 177039 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 618144 | |
| Uppercase Letter | 309072 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 8 | 63221 | |
| 1 | 63184 | |
| 4 | 63009 | |
| 3 | 62996 | |
| 2 | 62936 | |
| 9 | 62906 | |
| 7 | 62853 | |
| 6 | 62816 | |
| 5 | 62613 | |
| 0 | 51610 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 103024 | |
| I | 103024 | |
| D | 103024 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 618144 | |
| Latin | 309072 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 8 | 63221 | |
| 1 | 63184 | |
| 4 | 63009 | |
| 3 | 62996 | |
| 2 | 62936 | |
| 9 | 62906 | |
| 7 | 62853 | |
| 6 | 62816 | |
| 5 | 62613 | |
| 0 | 51610 |
Latin
| Value | Count | Frequency (%) |
| C | 103024 | |
| I | 103024 | |
| D | 103024 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 927216 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 103024 | |
| I | 103024 | |
| D | 103024 | |
| 8 | 63221 | 6.8% |
| 1 | 63184 | 6.8% |
| 4 | 63009 | 6.8% |
| 3 | 62996 | 6.8% |
| 2 | 62936 | 6.8% |
| 9 | 62906 | 6.8% |
| 7 | 62853 | 6.8% |
| Other values (3) | 177039 |
Vehicle_Type
Categorical
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.5 MiB |
| Prime Sedan | |
|---|---|
| eBike | |
| Auto | |
| Prime Plus | |
| Bike | |
| Other values (2) |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 6.7223948 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Prime Sedan |
|---|---|
| 2nd row | Bike |
| 3rd row | Prime SUV |
| 4th row | eBike |
| 5th row | Mini |
Common Values
| Value | Count | Frequency (%) |
| Prime Sedan | 14877 | |
| eBike | 14816 | |
| Auto | 14755 | |
| Prime Plus | 14707 | |
| Bike | 14662 | |
| Prime SUV | 14655 | |
| Mini | 14552 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| prime | 44239 | |
| sedan | 14877 | 10.1% |
| ebike | 14816 | 10.1% |
| auto | 14755 | 10.0% |
| plus | 14707 | 10.0% |
| bike | 14662 | 10.0% |
| suv | 14655 | 10.0% |
| mini | 14552 | 9.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 103410 | |
| i | 102821 | |
| P | 58946 | 8.5% |
| r | 44239 | 6.4% |
| m | 44239 | 6.4% |
| 44239 | 6.4% | |
| S | 29532 | 4.3% |
| k | 29478 | 4.3% |
| B | 29478 | 4.3% |
| u | 29462 | 4.3% |
| Other values (11) | 176724 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 471756 | |
| Uppercase Letter | 176573 | 25.5% |
| Space Separator | 44239 | 6.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 103410 | |
| i | 102821 | |
| r | 44239 | |
| m | 44239 | |
| k | 29478 | 6.2% |
| u | 29462 | 6.2% |
| n | 29429 | 6.2% |
| a | 14877 | 3.2% |
| d | 14877 | 3.2% |
| t | 14755 | 3.1% |
| Other values (3) | 44169 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 58946 | |
| S | 29532 | |
| B | 29478 | |
| A | 14755 | 8.4% |
| U | 14655 | 8.3% |
| V | 14655 | 8.3% |
| M | 14552 | 8.2% |
Space Separator
| Value | Count | Frequency (%) |
| 44239 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 648329 | |
| Common | 44239 | 6.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 103410 | |
| i | 102821 | |
| P | 58946 | |
| r | 44239 | 6.8% |
| m | 44239 | 6.8% |
| S | 29532 | 4.6% |
| k | 29478 | 4.5% |
| B | 29478 | 4.5% |
| u | 29462 | 4.5% |
| n | 29429 | 4.5% |
| Other values (10) | 147295 |
Common
| Value | Count | Frequency (%) |
| 44239 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 692568 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 103410 | |
| i | 102821 | |
| P | 58946 | 8.5% |
| r | 44239 | 6.4% |
| m | 44239 | 6.4% |
| 44239 | 6.4% | |
| S | 29532 | 4.3% |
| k | 29478 | 4.3% |
| B | 29478 | 4.3% |
| u | 29462 | 4.3% |
| Other values (11) | 176724 |
Pickup_Location
Categorical
| Distinct | 50 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 MiB |
| Banashankari | 2201 |
|---|---|
| Yeshwanthpur | 2139 |
| RT Nagar | 2135 |
| Indiranagar | 2133 |
| Sahakar Nagar | 2126 |
| Other values (45) |
Length
| Max length | 20 |
|---|---|
| Median length | 16 |
| Mean length | 10.525072 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Tumkur Road |
|---|---|
| 2nd row | Magadi Road |
| 3rd row | Sahakar Nagar |
| 4th row | HSR Layout |
| 5th row | Rajajinagar |
Common Values
| Value | Count | Frequency (%) |
| Banashankari | 2201 | 2.1% |
| Yeshwanthpur | 2139 | 2.1% |
| RT Nagar | 2135 | 2.1% |
| Indiranagar | 2133 | 2.1% |
| Sahakar Nagar | 2126 | 2.1% |
| Basavanagudi | 2120 | 2.1% |
| Ramamurthy Nagar | 2116 | 2.1% |
| Vijayanagar | 2113 | 2.1% |
| Tumkur Road | 2105 | 2.0% |
| Cox Town | 2100 | 2.0% |
| Other values (40) | 81736 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| road | 14527 | 10.1% |
| nagar | 10453 | 7.2% |
| town | 8269 | 5.7% |
| layout | 4133 | 2.9% |
| banashankari | 2201 | 1.5% |
| yeshwanthpur | 2139 | 1.5% |
| rt | 2135 | 1.5% |
| indiranagar | 2133 | 1.5% |
| sahakar | 2126 | 1.5% |
| basavanagudi | 2120 | 1.5% |
| Other values (46) | 94272 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 222500 | |
| r | 84641 | 7.8% |
| n | 66068 | 6.1% |
| i | 49361 | 4.6% |
| o | 47493 | 4.4% |
| h | 45263 | 4.2% |
| e | 43176 | 4.0% |
| 41484 | 3.8% | |
| g | 41243 | 3.8% |
| d | 35103 | 3.2% |
| Other values (37) | 408003 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 881797 | |
| Uppercase Letter | 161054 | 14.9% |
| Space Separator | 41484 | 3.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 222500 | |
| r | 84641 | 9.6% |
| n | 66068 | 7.5% |
| i | 49361 | 5.6% |
| o | 47493 | 5.4% |
| h | 45263 | 5.1% |
| e | 43176 | 4.9% |
| g | 41243 | 4.7% |
| d | 35103 | 4.0% |
| l | 34689 | 3.9% |
| Other values (15) | 212260 |
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 28909 | |
| T | 14600 | |
| M | 14475 | |
| N | 12536 | 7.8% |
| B | 10466 | 6.5% |
| H | 10294 | 6.4% |
| K | 10276 | 6.4% |
| S | 10267 | 6.4% |
| P | 8170 | 5.1% |
| C | 8119 | 5.0% |
| Other values (11) | 32942 |
Space Separator
| Value | Count | Frequency (%) |
| 41484 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1042851 | |
| Common | 41484 | 3.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 222500 | |
| r | 84641 | 8.1% |
| n | 66068 | 6.3% |
| i | 49361 | 4.7% |
| o | 47493 | 4.6% |
| h | 45263 | 4.3% |
| e | 43176 | 4.1% |
| g | 41243 | 4.0% |
| d | 35103 | 3.4% |
| l | 34689 | 3.3% |
| Other values (36) | 373314 |
Common
| Value | Count | Frequency (%) |
| 41484 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1084335 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 222500 | |
| r | 84641 | 7.8% |
| n | 66068 | 6.1% |
| i | 49361 | 4.6% |
| o | 47493 | 4.4% |
| h | 45263 | 4.2% |
| e | 43176 | 4.0% |
| 41484 | 3.8% | |
| g | 41243 | 3.8% |
| d | 35103 | 3.2% |
| Other values (37) | 408003 |
Drop_Location
Categorical
| Distinct | 50 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.8 MiB |
| Peenya | 2159 |
|---|---|
| Mysore Road | 2148 |
| MG Road | 2128 |
| Hennur | 2120 |
| HSR Layout | 2117 |
| Other values (45) |
Length
| Max length | 20 |
|---|---|
| Median length | 16 |
| Mean length | 10.505067 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RT Nagar |
|---|---|
| 2nd row | Varthur |
| 3rd row | Varthur |
| 4th row | Vijayanagar |
| 5th row | Chamarajpet |
Common Values
| Value | Count | Frequency (%) |
| Peenya | 2159 | 2.1% |
| Mysore Road | 2148 | 2.1% |
| MG Road | 2128 | 2.1% |
| Hennur | 2120 | 2.1% |
| HSR Layout | 2117 | 2.1% |
| Sarjapur Road | 2108 | 2.0% |
| Koramangala | 2105 | 2.0% |
| Marathahalli | 2104 | 2.0% |
| Vijayanagar | 2103 | 2.0% |
| Hebbal | 2097 | 2.0% |
| Other values (40) | 81835 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| road | 14661 | 10.2% |
| nagar | 10275 | 7.1% |
| town | 8135 | 5.6% |
| layout | 4213 | 2.9% |
| peenya | 2159 | 1.5% |
| mysore | 2148 | 1.5% |
| mg | 2128 | 1.5% |
| hennur | 2120 | 1.5% |
| hsr | 2117 | 1.5% |
| sarjapur | 2108 | 1.5% |
| Other values (46) | 94306 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 222561 | |
| r | 84371 | 7.8% |
| n | 65829 | 6.1% |
| i | 48955 | 4.5% |
| o | 47548 | 4.4% |
| h | 44912 | 4.1% |
| e | 43208 | 4.0% |
| 41346 | 3.8% | |
| g | 41190 | 3.8% |
| d | 35003 | 3.2% |
| Other values (37) | 407351 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 879779 | |
| Uppercase Letter | 161149 | 14.9% |
| Space Separator | 41346 | 3.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 222561 | |
| r | 84371 | 9.6% |
| n | 65829 | 7.5% |
| i | 48955 | 5.6% |
| o | 47548 | 5.4% |
| h | 44912 | 5.1% |
| e | 43208 | 4.9% |
| g | 41190 | 4.7% |
| d | 35003 | 4.0% |
| l | 34846 | 4.0% |
| Other values (15) | 211356 |
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 28974 | |
| M | 14650 | |
| T | 14380 | |
| N | 12292 | 7.6% |
| H | 10458 | 6.5% |
| S | 10422 | 6.5% |
| K | 10393 | 6.4% |
| B | 10340 | 6.4% |
| P | 8332 | 5.2% |
| C | 8083 | 5.0% |
| Other values (11) | 32825 |
Space Separator
| Value | Count | Frequency (%) |
| 41346 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1040928 | |
| Common | 41346 | 3.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 222561 | |
| r | 84371 | 8.1% |
| n | 65829 | 6.3% |
| i | 48955 | 4.7% |
| o | 47548 | 4.6% |
| h | 44912 | 4.3% |
| e | 43208 | 4.2% |
| g | 41190 | 4.0% |
| d | 35003 | 3.4% |
| l | 34846 | 3.3% |
| Other values (36) | 372505 |
Common
| Value | Count | Frequency (%) |
| 41346 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1082274 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 222561 | |
| r | 84371 | 7.8% |
| n | 65829 | 6.1% |
| i | 48955 | 4.5% |
| o | 47548 | 4.4% |
| h | 44912 | 4.1% |
| e | 43208 | 4.0% |
| 41346 | 3.8% | |
| g | 41190 | 3.8% |
| d | 35003 | 3.2% |
| Other values (37) | 407351 |
V_TAT
Real number (ℝ)
High correlation Missing
| Distinct | 40 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 39057 |
| Missing (%) | 37.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 170.87695 |
| Minimum | 35 |
|---|---|
| Maximum | 308 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.0 KiB |
Quantile statistics
| Minimum | 35 |
|---|---|
| 5-th percentile | 49 |
| Q1 | 98 |
| median | 168 |
| Q3 | 238 |
| 95-th percentile | 301 |
| Maximum | 308 |
| Range | 273 |
| Interquartile range (IQR) | 140 |
Descriptive statistics
| Standard deviation | 80.80364 |
|---|---|
| Coefficient of variation (CV) | 0.47287617 |
| Kurtosis | -1.201942 |
| Mean | 170.87695 |
| Median Absolute Deviation (MAD) | 70 |
| Skewness | 0.013318788 |
| Sum | 10930486 |
| Variance | 6529.2282 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=40)
| Value | Count | Frequency (%) |
| 56 | 1670 | 1.6% |
| 196 | 1665 | 1.6% |
| 105 | 1652 | 1.6% |
| 168 | 1650 | 1.6% |
| 126 | 1644 | 1.6% |
| 224 | 1637 | 1.6% |
| 98 | 1632 | 1.6% |
| 63 | 1631 | 1.6% |
| 308 | 1630 | 1.6% |
| 84 | 1628 | 1.6% |
| Other values (30) | 47528 | |
| (Missing) | 39057 |
| Value | Count | Frequency (%) |
| 35 | 1584 | |
| 42 | 1606 | |
| 49 | 1564 | |
| 56 | 1670 | |
| 63 | 1631 | |
| 70 | 1614 | |
| 77 | 1623 | |
| 84 | 1628 | |
| 91 | 1624 | |
| 98 | 1632 |
| Value | Count | Frequency (%) |
| 308 | 1630 | |
| 301 | 1594 | |
| 294 | 1555 | |
| 287 | 1553 | |
| 280 | 1611 | |
| 273 | 1564 | |
| 266 | 1589 | |
| 259 | 1597 | |
| 252 | 1571 | |
| 245 | 1567 |
C_TAT
Real number (ℝ)
High correlation Missing
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 39057 |
| Missing (%) | 37.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 84.873372 |
| Minimum | 25 |
|---|---|
| Maximum | 145 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.0 KiB |
Quantile statistics
| Minimum | 25 |
|---|---|
| 5-th percentile | 30 |
| Q1 | 55 |
| median | 85 |
| Q3 | 115 |
| 95-th percentile | 140 |
| Maximum | 145 |
| Range | 120 |
| Interquartile range (IQR) | 60 |
Descriptive statistics
| Standard deviation | 36.0051 |
|---|---|
| Coefficient of variation (CV) | 0.42422139 |
| Kurtosis | -1.2023627 |
| Mean | 84.873372 |
| Median Absolute Deviation (MAD) | 30 |
| Skewness | 0.0072118859 |
| Sum | 5429095 |
| Variance | 1296.3672 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=25)
| Value | Count | Frequency (%) |
| 60 | 2664 | 2.6% |
| 55 | 2642 | 2.6% |
| 95 | 2631 | 2.6% |
| 40 | 2627 | 2.5% |
| 35 | 2626 | 2.5% |
| 110 | 2588 | 2.5% |
| 105 | 2585 | 2.5% |
| 115 | 2577 | 2.5% |
| 100 | 2576 | 2.5% |
| 145 | 2574 | 2.5% |
| Other values (15) | 37877 | |
| (Missing) | 39057 |
| Value | Count | Frequency (%) |
| 25 | 2478 | |
| 30 | 2560 | |
| 35 | 2626 | |
| 40 | 2627 | |
| 45 | 2525 | |
| 50 | 2519 | |
| 55 | 2642 | |
| 60 | 2664 | |
| 65 | 2541 | |
| 70 | 2528 |
| Value | Count | Frequency (%) |
| 145 | 2574 | |
| 140 | 2548 | |
| 135 | 2513 | |
| 130 | 2537 | |
| 125 | 2431 | |
| 120 | 2565 | |
| 115 | 2577 | |
| 110 | 2588 | |
| 105 | 2585 | |
| 100 | 2576 |
Canceled_Rides_by_Customer
Categorical
High correlation Missing
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 92525 |
| Missing (%) | 89.8% |
| Memory size | 5.7 MiB |
| Driver is not moving towards pickup location | |
|---|---|
| Driver asked to cancel | |
| Change of plans | |
| AC is Not working | |
| Wrong Address |
Length
| Max length | 44 |
|---|---|
| Median length | 22 |
| Mean length | 25.657301 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Driver is not moving towards pickup location |
|---|---|
| 2nd row | Driver asked to cancel |
| 3rd row | Driver is not moving towards pickup location |
| 4th row | AC is Not working |
| 5th row | Driver asked to cancel |
Common Values
| Value | Count | Frequency (%) |
| Driver is not moving towards pickup location | 3175 | 3.1% |
| Driver asked to cancel | 2670 | 2.6% |
| Change of plans | 2081 | 2.0% |
| AC is Not working | 1568 | 1.5% |
| Wrong Address | 1005 | 1.0% |
| (Missing) | 92525 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| driver | 5845 | |
| is | 4743 | |
| not | 4743 | |
| moving | 3175 | 6.7% |
| towards | 3175 | 6.7% |
| pickup | 3175 | 6.7% |
| location | 3175 | 6.7% |
| cancel | 2670 | 5.6% |
| to | 2670 | 5.6% |
| asked | 2670 | 5.6% |
| Other values (7) | 11389 |
Most occurring characters
| Value | Count | Frequency (%) |
| 36931 | ||
| o | 24767 | 9.2% |
| i | 21681 | 8.0% |
| n | 18930 | 7.0% |
| r | 18443 | 6.8% |
| a | 15852 | 5.9% |
| s | 14679 | 5.4% |
| e | 14271 | 5.3% |
| t | 13763 | 5.1% |
| c | 11690 | 4.3% |
| Other values (16) | 78369 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 217805 | |
| Space Separator | 36931 | 13.7% |
| Uppercase Letter | 14640 | 5.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 24767 | |
| i | 21681 | 10.0% |
| n | 18930 | 8.7% |
| r | 18443 | 8.5% |
| a | 15852 | 7.3% |
| s | 14679 | 6.7% |
| e | 14271 | 6.6% |
| t | 13763 | 6.3% |
| c | 11690 | 5.4% |
| v | 9020 | 4.1% |
| Other values (10) | 54709 |
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 5845 | |
| C | 3649 | |
| A | 2573 | |
| N | 1568 | 10.7% |
| W | 1005 | 6.9% |
Space Separator
| Value | Count | Frequency (%) |
| 36931 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 232445 | |
| Common | 36931 | 13.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 24767 | 10.7% |
| i | 21681 | 9.3% |
| n | 18930 | 8.1% |
| r | 18443 | 7.9% |
| a | 15852 | 6.8% |
| s | 14679 | 6.3% |
| e | 14271 | 6.1% |
| t | 13763 | 5.9% |
| c | 11690 | 5.0% |
| v | 9020 | 3.9% |
| Other values (15) | 69349 |
Common
| Value | Count | Frequency (%) |
| 36931 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 269376 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 36931 | ||
| o | 24767 | 9.2% |
| i | 21681 | 8.0% |
| n | 18930 | 7.0% |
| r | 18443 | 6.8% |
| a | 15852 | 5.9% |
| s | 14679 | 5.4% |
| e | 14271 | 5.3% |
| t | 13763 | 5.1% |
| c | 11690 | 4.3% |
| Other values (16) | 78369 |
Canceled_Rides_by_Driver
Categorical
High correlation Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 84590 |
| Missing (%) | 82.1% |
| Memory size | 5.9 MiB |
| Personal & Car related issue | |
|---|---|
| Customer related issue | |
| Customer was coughing/sick | |
| More than permitted people in there |
Length
| Max length | 35 |
|---|---|
| Median length | 28 |
| Mean length | 26.914452 |
| Min length | 22 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Personal & Car related issue |
|---|---|
| 2nd row | Personal & Car related issue |
| 3rd row | Personal & Car related issue |
| 4th row | Personal & Car related issue |
| 5th row | Customer was coughing/sick |
Common Values
| Value | Count | Frequency (%) |
| Personal & Car related issue | 6542 | 6.3% |
| Customer related issue | 5413 | 5.3% |
| Customer was coughing/sick | 3654 | 3.5% |
| More than permitted people in there | 2825 | 2.7% |
| (Missing) | 84590 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| related | 11955 | |
| issue | 11955 | |
| customer | 9067 | |
| personal | 6542 | |
| 6542 | ||
| car | 6542 | |
| was | 3654 | 4.8% |
| coughing/sick | 3654 | 4.8% |
| more | 2825 | 3.7% |
| than | 2825 | 3.7% |
| Other values (4) | 11300 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 71249 | |
| 58427 | ||
| s | 46827 | 9.4% |
| r | 42581 | 8.6% |
| t | 32322 | 6.5% |
| a | 31518 | 6.4% |
| o | 24913 | 5.0% |
| i | 24913 | 5.0% |
| u | 24676 | 5.0% |
| l | 21322 | 4.3% |
| Other values (14) | 117393 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 402542 | |
| Space Separator | 58427 | 11.8% |
| Uppercase Letter | 24976 | 5.0% |
| Other Punctuation | 10196 | 2.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 71249 | |
| s | 46827 | |
| r | 42581 | |
| t | 32322 | |
| a | 31518 | |
| o | 24913 | 6.2% |
| i | 24913 | 6.2% |
| u | 24676 | 6.1% |
| l | 21322 | 5.3% |
| n | 15846 | 3.9% |
| Other values (8) | 66375 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 15609 | |
| P | 6542 | |
| M | 2825 | 11.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 6542 | |
| / | 3654 |
Space Separator
| Value | Count | Frequency (%) |
| 58427 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 427518 | |
| Common | 68623 | 13.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 71249 | |
| s | 46827 | |
| r | 42581 | |
| t | 32322 | 7.6% |
| a | 31518 | 7.4% |
| o | 24913 | 5.8% |
| i | 24913 | 5.8% |
| u | 24676 | 5.8% |
| l | 21322 | 5.0% |
| n | 15846 | 3.7% |
| Other values (11) | 91351 |
Common
| Value | Count | Frequency (%) |
| 58427 | ||
| & | 6542 | 9.5% |
| / | 3654 | 5.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 496141 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 71249 | |
| 58427 | ||
| s | 46827 | 9.4% |
| r | 42581 | 8.6% |
| t | 32322 | 6.5% |
| a | 31518 | 6.4% |
| o | 24913 | 5.0% |
| i | 24913 | 5.0% |
| u | 24676 | 5.0% |
| l | 21322 | 4.3% |
| Other values (14) | 117393 |
Incomplete_Rides
Boolean
High correlation Imbalance Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 39057 |
| Missing (%) | 37.9% |
| Memory size | 201.3 KiB |
| False | |
|---|---|
| True | 3926 |
| (Missing) |
| Value | Count | Frequency (%) |
| False | 60041 | |
| True | 3926 | 3.8% |
| (Missing) | 39057 |
Incomplete_Rides_Reason
Categorical
High correlation Missing
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 99098 |
| Missing (%) | 96.2% |
| Memory size | 5.5 MiB |
| Customer Demand | |
|---|---|
| Vehicle Breakdown | |
| Other Issue |
Length
| Max length | 17 |
|---|---|
| Median length | 15 |
| Mean length | 15.062659 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Customer Demand |
|---|---|
| 2nd row | Vehicle Breakdown |
| 3rd row | Customer Demand |
| 4th row | Other Issue |
| 5th row | Other Issue |
Common Values
| Value | Count | Frequency (%) |
| Customer Demand | 1601 | 1.6% |
| Vehicle Breakdown | 1591 | 1.5% |
| Other Issue | 734 | 0.7% |
| (Missing) | 99098 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| customer | 1601 | |
| demand | 1601 | |
| vehicle | 1591 | |
| breakdown | 1591 | |
| other | 734 | |
| issue | 734 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 9443 | |
| r | 3926 | 6.6% |
| 3926 | 6.6% | |
| m | 3202 | 5.4% |
| n | 3192 | 5.4% |
| d | 3192 | 5.4% |
| o | 3192 | 5.4% |
| a | 3192 | 5.4% |
| s | 3069 | 5.2% |
| t | 2335 | 3.9% |
| Other values (13) | 20467 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 47358 | |
| Uppercase Letter | 7852 | 13.3% |
| Space Separator | 3926 | 6.6% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 9443 | |
| r | 3926 | 8.3% |
| m | 3202 | 6.8% |
| n | 3192 | 6.7% |
| d | 3192 | 6.7% |
| o | 3192 | 6.7% |
| a | 3192 | 6.7% |
| s | 3069 | 6.5% |
| t | 2335 | 4.9% |
| u | 2335 | 4.9% |
| Other values (6) | 10280 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 1601 | |
| D | 1601 | |
| V | 1591 | |
| B | 1591 | |
| O | 734 | |
| I | 734 |
Space Separator
| Value | Count | Frequency (%) |
| 3926 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 55210 | |
| Common | 3926 | 6.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 9443 | |
| r | 3926 | 7.1% |
| m | 3202 | 5.8% |
| n | 3192 | 5.8% |
| d | 3192 | 5.8% |
| o | 3192 | 5.8% |
| a | 3192 | 5.8% |
| s | 3069 | 5.6% |
| t | 2335 | 4.2% |
| u | 2335 | 4.2% |
| Other values (12) | 18132 |
Common
| Value | Count | Frequency (%) |
| 3926 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 59136 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 9443 | |
| r | 3926 | 6.6% |
| 3926 | 6.6% | |
| m | 3202 | 5.4% |
| n | 3192 | 5.4% |
| d | 3192 | 5.4% |
| o | 3192 | 5.4% |
| a | 3192 | 5.4% |
| s | 3069 | 5.2% |
| t | 2335 | 3.9% |
| Other values (13) | 20467 |
Booking_Value
Real number (ℝ)
| Distinct | 2883 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 548.75188 |
| Minimum | 100 |
|---|---|
| Maximum | 2999 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.0 KiB |
Quantile statistics
| Minimum | 100 |
|---|---|
| 5-th percentile | 128 |
| Q1 | 242 |
| median | 386 |
| Q3 | 621 |
| 95-th percentile | 1899 |
| Maximum | 2999 |
| Range | 2899 |
| Interquartile range (IQR) | 379 |
Descriptive statistics
| Standard deviation | 536.54122 |
|---|---|
| Coefficient of variation (CV) | 0.9777483 |
| Kurtosis | 6.8312418 |
| Mean | 548.75188 |
| Median Absolute Deviation (MAD) | 162 |
| Skewness | 2.5717109 |
| Sum | 56534614 |
| Variance | 287876.48 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 305 | 226 | 0.2% |
| 459 | 216 | 0.2% |
| 191 | 215 | 0.2% |
| 256 | 214 | 0.2% |
| 470 | 212 | 0.2% |
| 176 | 210 | 0.2% |
| 400 | 210 | 0.2% |
| 493 | 208 | 0.2% |
| 142 | 208 | 0.2% |
| 186 | 207 | 0.2% |
| Other values (2873) | 100898 |
| Value | Count | Frequency (%) |
| 100 | 160 | |
| 101 | 174 | |
| 102 | 169 | |
| 103 | 166 | |
| 104 | 192 | |
| 105 | 183 | |
| 106 | 193 | |
| 107 | 163 | |
| 108 | 163 | |
| 109 | 197 |
| Value | Count | Frequency (%) |
| 2999 | 3 | < 0.1% |
| 2998 | 8 | |
| 2997 | 5 | |
| 2996 | 4 | |
| 2995 | 3 | < 0.1% |
| 2994 | 5 | |
| 2993 | 6 | |
| 2991 | 4 | |
| 2990 | 4 | |
| 2989 | 6 |
Payment_Method
Categorical
High correlation Missing
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 39057 |
| Missing (%) | 37.9% |
| Memory size | 5.3 MiB |
| Cash | |
|---|---|
| UPI | |
| Credit Card | 2435 |
| Debit Card | 629 |
Length
| Max length | 11 |
|---|---|
| Median length | 4 |
| Mean length | 3.9208654 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cash |
|---|---|
| 2nd row | UPI |
| 3rd row | Credit Card |
| 4th row | UPI |
| 5th row | Cash |
Common Values
| Value | Count | Frequency (%) |
| Cash | 35022 | |
| UPI | 25881 | |
| Credit Card | 2435 | 2.4% |
| Debit Card | 629 | 0.6% |
| (Missing) | 39057 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| cash | 35022 | |
| upi | 25881 | |
| card | 3064 | 4.6% |
| credit | 2435 | 3.6% |
| debit | 629 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 40521 | |
| a | 38086 | |
| s | 35022 | |
| h | 35022 | |
| U | 25881 | |
| P | 25881 | |
| I | 25881 | |
| r | 5499 | 2.2% |
| d | 5499 | 2.2% |
| e | 3064 | 1.2% |
| Other values (5) | 10450 | 4.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 128949 | |
| Uppercase Letter | 118793 | |
| Space Separator | 3064 | 1.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 38086 | |
| s | 35022 | |
| h | 35022 | |
| r | 5499 | 4.3% |
| d | 5499 | 4.3% |
| e | 3064 | 2.4% |
| i | 3064 | 2.4% |
| t | 3064 | 2.4% |
| b | 629 | 0.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 40521 | |
| U | 25881 | |
| P | 25881 | |
| I | 25881 | |
| D | 629 | 0.5% |
Space Separator
| Value | Count | Frequency (%) |
| 3064 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 247742 | |
| Common | 3064 | 1.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 40521 | |
| a | 38086 | |
| s | 35022 | |
| h | 35022 | |
| U | 25881 | |
| P | 25881 | |
| I | 25881 | |
| r | 5499 | 2.2% |
| d | 5499 | 2.2% |
| e | 3064 | 1.2% |
| Other values (4) | 7386 | 3.0% |
Common
| Value | Count | Frequency (%) |
| 3064 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 250806 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 40521 | |
| a | 38086 | |
| s | 35022 | |
| h | 35022 | |
| U | 25881 | |
| P | 25881 | |
| I | 25881 | |
| r | 5499 | 2.2% |
| d | 5499 | 2.2% |
| e | 3064 | 1.2% |
| Other values (5) | 10450 | 4.2% |
Ride_Distance
Real number (ℝ)
High correlation Zeros
| Distinct | 50 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.189927 |
| Minimum | 0 |
|---|---|
| Maximum | 49 |
| Zeros | 39057 |
| Zeros (%) | 37.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.0 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 8 |
| Q3 | 26 |
| 95-th percentile | 45 |
| Maximum | 49 |
| Range | 49 |
| Interquartile range (IQR) | 26 |
Descriptive statistics
| Standard deviation | 15.77627 |
|---|---|
| Coefficient of variation (CV) | 1.1117936 |
| Kurtosis | -0.81346365 |
| Mean | 14.189927 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 0.76059922 |
| Sum | 1461903 |
| Variance | 248.89068 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 39057 | |
| 10 | 1684 | 1.6% |
| 14 | 1657 | 1.6% |
| 1 | 1654 | 1.6% |
| 16 | 1624 | 1.6% |
| 4 | 1618 | 1.6% |
| 5 | 1601 | 1.6% |
| 18 | 1598 | 1.6% |
| 15 | 1597 | 1.6% |
| 17 | 1596 | 1.5% |
| Other values (40) | 49338 |
| Value | Count | Frequency (%) |
| 0 | 39057 | |
| 1 | 1654 | 1.6% |
| 2 | 1595 | 1.5% |
| 3 | 1574 | 1.5% |
| 4 | 1618 | 1.6% |
| 5 | 1601 | 1.6% |
| 6 | 1514 | 1.5% |
| 7 | 1587 | 1.5% |
| 8 | 1573 | 1.5% |
| 9 | 1594 | 1.5% |
| Value | Count | Frequency (%) |
| 49 | 1109 | |
| 48 | 1036 | |
| 47 | 1133 | |
| 46 | 1126 | |
| 45 | 1163 | |
| 44 | 1097 | |
| 43 | 1120 | |
| 42 | 1159 | |
| 41 | 1101 | |
| 40 | 1074 |
Driver_Ratings
Real number (ℝ)
High correlation
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9946297 |
| Minimum | 3 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.0 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 3.2 |
| Q1 | 3.8 |
| median | 3.99 |
| Q3 | 4.2 |
| 95-th percentile | 4.8 |
| Maximum | 5 |
| Range | 2 |
| Interquartile range (IQR) | 0.4 |
Descriptive statistics
| Standard deviation | 0.45454034 |
|---|---|
| Coefficient of variation (CV) | 0.11378785 |
| Kurtosis | -0.072567932 |
| Mean | 3.9946297 |
| Median Absolute Deviation (MAD) | 0.19 |
| Skewness | 0.021121088 |
| Sum | 411542.73 |
| Variance | 0.20660692 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=22)
| Value | Count | Frequency (%) |
| 3.99 | 39057 | |
| 3.8 | 3313 | 3.2% |
| 3.9 | 3274 | 3.2% |
| 3.1 | 3273 | 3.2% |
| 4.2 | 3259 | 3.2% |
| 3.3 | 3249 | 3.2% |
| 3.5 | 3235 | 3.1% |
| 4.7 | 3232 | 3.1% |
| 4.1 | 3231 | 3.1% |
| 4.5 | 3214 | 3.1% |
| Other values (12) | 34687 |
| Value | Count | Frequency (%) |
| 3 | 1560 | |
| 3.1 | 3273 | |
| 3.2 | 3161 | |
| 3.3 | 3249 | |
| 3.4 | 3130 | |
| 3.5 | 3235 | |
| 3.6 | 3124 | |
| 3.7 | 3208 | |
| 3.8 | 3313 | |
| 3.9 | 3274 |
| Value | Count | Frequency (%) |
| 5 | 1531 | |
| 4.9 | 3105 | |
| 4.8 | 3176 | |
| 4.7 | 3232 | |
| 4.6 | 3183 | |
| 4.5 | 3214 | |
| 4.4 | 3185 | |
| 4.3 | 3164 | |
| 4.2 | 3259 | |
| 4.1 | 3231 |
Customer_Rating
Real number (ℝ)
High correlation Missing
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 39057 |
| Missing (%) | 37.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9983132 |
| Minimum | 3 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 805.0 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 3.1 |
| Q1 | 3.5 |
| median | 4 |
| Q3 | 4.5 |
| 95-th percentile | 4.9 |
| Maximum | 5 |
| Range | 2 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.57895737 |
|---|---|
| Coefficient of variation (CV) | 0.1448004 |
| Kurtosis | -1.1864231 |
| Mean | 3.9983132 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | 0.0066774677 |
| Sum | 255760.1 |
| Variance | 0.33519163 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 4.9 | 3289 | 3.2% |
| 3.9 | 3286 | 3.2% |
| 3.5 | 3275 | 3.2% |
| 3.7 | 3264 | 3.2% |
| 4 | 3259 | 3.2% |
| 3.2 | 3222 | 3.1% |
| 4.8 | 3216 | 3.1% |
| 4.4 | 3210 | 3.1% |
| 3.4 | 3210 | 3.1% |
| 3.3 | 3194 | 3.1% |
| Other values (11) | 31542 | |
| (Missing) | 39057 |
| Value | Count | Frequency (%) |
| 3 | 1651 | |
| 3.1 | 3130 | |
| 3.2 | 3222 | |
| 3.3 | 3194 | |
| 3.4 | 3210 | |
| 3.5 | 3275 | |
| 3.6 | 3168 | |
| 3.7 | 3264 | |
| 3.8 | 3102 | |
| 3.9 | 3286 |
| Value | Count | Frequency (%) |
| 5 | 1566 | |
| 4.9 | 3289 | |
| 4.8 | 3216 | |
| 4.7 | 3126 | |
| 4.6 | 3129 | |
| 4.5 | 3173 | |
| 4.4 | 3210 | |
| 4.3 | 3152 | |
| 4.2 | 3173 | |
| 4.1 | 3172 |
Interactions
Correlations
| Booking_Status | Booking_Value | C_TAT | Canceled_Rides_by_Customer | Canceled_Rides_by_Driver | Customer_Rating | Driver_Ratings | Drop_Location | Incomplete_Rides | Incomplete_Rides_Reason | Payment_Method | Pickup_Location | Ride_Distance | V_TAT | Vehicle_Type | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Booking_Status | 1.000 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.507 | 0.001 | 1.000 | 1.000 | 1.000 | 0.009 | 0.507 | 1.000 | 0.002 |
| Booking_Value | 0.000 | 1.000 | -0.000 | 0.000 | 0.020 | 0.007 | 0.000 | 0.006 | 0.012 | 0.030 | 0.000 | 0.000 | -0.001 | -0.005 | 0.005 |
| C_TAT | 1.000 | -0.000 | 1.000 | 0.000 | 0.000 | 0.001 | -0.003 | 0.007 | 0.000 | 0.041 | 0.000 | 0.009 | -0.000 | 0.000 | 0.007 |
| Canceled_Rides_by_Customer | 1.000 | 0.000 | 0.000 | 1.000 | 0.000 | 0.000 | 1.000 | 0.022 | 0.000 | 0.000 | 0.000 | 0.014 | 1.000 | 0.000 | 0.000 |
| Canceled_Rides_by_Driver | 1.000 | 0.020 | 0.000 | 0.000 | 1.000 | 0.000 | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.023 | 1.000 | 0.000 | 0.000 |
| Customer_Rating | 1.000 | 0.007 | 0.001 | 0.000 | 0.000 | 1.000 | -0.003 | 0.000 | 0.006 | 0.000 | 0.007 | 0.011 | 0.010 | 0.001 | 0.006 |
| Driver_Ratings | 0.507 | 0.000 | -0.003 | 1.000 | 1.000 | -0.003 | 1.000 | 0.004 | 0.000 | 0.000 | 0.008 | 0.004 | 0.031 | -0.002 | 0.005 |
| Drop_Location | 0.001 | 0.006 | 0.007 | 0.022 | 0.000 | 0.000 | 0.004 | 1.000 | 0.000 | 0.000 | 0.007 | 0.004 | 0.007 | 0.002 | 0.000 |
| Incomplete_Rides | 1.000 | 0.012 | 0.000 | 0.000 | 0.000 | 0.006 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.013 | 0.008 | 0.009 | 0.003 |
| Incomplete_Rides_Reason | 1.000 | 0.030 | 0.041 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.013 | 0.000 | 0.000 |
| Payment_Method | 1.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.007 | 0.008 | 0.007 | 0.000 | 0.000 | 1.000 | 0.004 | 0.000 | 0.006 | 0.000 |
| Pickup_Location | 0.009 | 0.000 | 0.009 | 0.014 | 0.023 | 0.011 | 0.004 | 0.004 | 0.013 | 0.000 | 0.004 | 1.000 | 0.003 | 0.007 | 0.003 |
| Ride_Distance | 0.507 | -0.001 | -0.000 | 1.000 | 1.000 | 0.010 | 0.031 | 0.007 | 0.008 | 0.013 | 0.000 | 0.003 | 1.000 | -0.011 | 0.132 |
| V_TAT | 1.000 | -0.005 | 0.000 | 0.000 | 0.000 | 0.001 | -0.002 | 0.002 | 0.009 | 0.000 | 0.006 | 0.007 | -0.011 | 1.000 | 0.003 |
| Vehicle_Type | 0.002 | 0.005 | 0.007 | 0.000 | 0.000 | 0.006 | 0.005 | 0.000 | 0.003 | 0.000 | 0.000 | 0.003 | 0.132 | 0.003 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| Date | Time | Booking_ID | Booking_Status | Customer_ID | Vehicle_Type | Pickup_Location | Drop_Location | V_TAT | C_TAT | Canceled_Rides_by_Customer | Canceled_Rides_by_Driver | Incomplete_Rides | Incomplete_Rides_Reason | Booking_Value | Payment_Method | Ride_Distance | Driver_Ratings | Customer_Rating | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 26-07-2024 14:00 | 14:00:00 | CNR7153255142 | Canceled by Driver | CID713523 | Prime Sedan | Tumkur Road | RT Nagar | NaN | NaN | NaN | Personal & Car related issue | NaN | NaN | 444 | NaN | 0 | 3.99 | NaN |
| 1 | 25-07-2024 22:20 | 22:20:00 | CNR2940424040 | Success | CID225428 | Bike | Magadi Road | Varthur | 203.0 | 30.0 | NaN | NaN | No | NaN | 158 | Cash | 13 | 4.10 | 4.0 |
| 2 | 30-07-2024 19:59 | 19:59:00 | CNR2982357879 | Success | CID270156 | Prime SUV | Sahakar Nagar | Varthur | 238.0 | 130.0 | NaN | NaN | No | NaN | 386 | UPI | 40 | 4.20 | 4.8 |
| 3 | 22-07-2024 03:15 | 03:15:00 | CNR2395710036 | Canceled by Customer | CID581320 | eBike | HSR Layout | Vijayanagar | NaN | NaN | Driver is not moving towards pickup location | NaN | NaN | NaN | 384 | NaN | 0 | 3.99 | NaN |
| 4 | 02-07-2024 09:02 | 09:02:00 | CNR1797421769 | Success | CID939555 | Mini | Rajajinagar | Chamarajpet | 252.0 | 80.0 | NaN | NaN | No | NaN | 822 | Credit Card | 45 | 4.00 | 3.0 |
| 5 | 13-07-2024 04:42 | 04:42:00 | CNR8787177882 | Success | CID802429 | Mini | Kadugodi | Vijayanagar | 231.0 | 90.0 | NaN | NaN | No | NaN | 173 | UPI | 41 | 3.40 | 4.6 |
| 6 | 23-07-2024 09:51 | 09:51:00 | CNR3612067560 | Success | CID476071 | Bike | Tumkur Road | Whitefield | 133.0 | 40.0 | NaN | NaN | No | NaN | 140 | Cash | 49 | 3.20 | 4.5 |
| 7 | 11-07-2024 11:12 | 11:12:00 | CNR5374902489 | Canceled by Driver | CID735691 | Prime Plus | Bannerghatta Road | Sarjapur Road | NaN | NaN | NaN | Personal & Car related issue | NaN | NaN | 344 | NaN | 0 | 3.99 | NaN |
| 8 | 01-07-2024 19:19 | 19:19:00 | CNR5030602354 | Driver Not Found | CID999840 | Mini | Chamarajpet | Peenya | NaN | NaN | NaN | NaN | NaN | NaN | 839 | NaN | 0 | 3.99 | NaN |
| 9 | 18-07-2024 01:31 | 01:31:00 | CNR6328453219 | Canceled by Driver | CID907133 | Auto | RT Nagar | Varthur | NaN | NaN | NaN | Personal & Car related issue | NaN | NaN | 893 | NaN | 0 | 3.99 | NaN |
| Date | Time | Booking_ID | Booking_Status | Customer_ID | Vehicle_Type | Pickup_Location | Drop_Location | V_TAT | C_TAT | Canceled_Rides_by_Customer | Canceled_Rides_by_Driver | Incomplete_Rides | Incomplete_Rides_Reason | Booking_Value | Payment_Method | Ride_Distance | Driver_Ratings | Customer_Rating | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 103014 | 31-07-2024 17:11 | 17:11:00 | CNR8606968614 | Driver Not Found | CID259664 | Bike | Banashankari | Yelahanka | NaN | NaN | NaN | NaN | NaN | NaN | 545 | NaN | 0 | 3.99 | NaN |
| 103015 | 31-07-2024 17:43 | 17:43:00 | CNR1504131542 | Canceled by Driver | CID663450 | Prime Plus | Bellandur | Hulimavu | NaN | NaN | NaN | Customer related issue | NaN | NaN | 461 | NaN | 0 | 3.99 | NaN |
| 103016 | 31-07-2024 09:20 | 09:20:00 | CNR3395373353 | Driver Not Found | CID355268 | Prime Sedan | Malleshwaram | Tumkur Road | NaN | NaN | NaN | NaN | NaN | NaN | 1671 | NaN | 0 | 3.99 | NaN |
| 103017 | 31-07-2024 19:34 | 19:34:00 | CNR4870774895 | Success | CID266336 | Prime Sedan | Marathahalli | Cox Town | 189.0 | 30.0 | NaN | NaN | No | NaN | 280 | UPI | 38 | 3.40 | 4.1 |
| 103018 | 31-07-2024 03:00 | 03:00:00 | CNR9738039746 | Success | CID922711 | eBike | Chickpet | RT Nagar | 42.0 | 135.0 | NaN | NaN | No | NaN | 310 | UPI | 7 | 3.80 | 3.3 |
| 103019 | 31-07-2024 09:06 | 09:06:00 | CNR9488489435 | Success | CID371654 | Prime Plus | Richmond Town | Varthur | 245.0 | 35.0 | NaN | NaN | No | NaN | 111 | Cash | 41 | 3.60 | 3.8 |
| 103020 | 31-07-2024 15:12 | 15:12:00 | CNR3151743100 | Success | CID334158 | Auto | Vijayanagar | Richmond Town | 84.0 | 145.0 | NaN | NaN | No | NaN | 1097 | UPI | 17 | 4.30 | 3.3 |
| 103021 | 31-07-2024 13:59 | 13:59:00 | CNR1286151233 | Success | CID113188 | Prime SUV | Bannerghatta Road | JP Nagar | 35.0 | 75.0 | NaN | NaN | No | NaN | 2201 | Cash | 37 | 3.60 | 3.2 |
| 103022 | 31-07-2024 14:56 | 14:56:00 | CNR2027162035 | Success | CID118301 | eBike | Indiranagar | Magadi Road | 210.0 | 140.0 | NaN | NaN | No | NaN | 267 | UPI | 47 | 3.40 | 3.1 |
| 103023 | 31-07-2024 13:57 | 13:57:00 | CNR9770709721 | Success | CID217959 | Auto | Ulsoor | Hennur | 175.0 | 125.0 | NaN | NaN | No | NaN | 462 | UPI | 3 | 4.80 | 4.4 |